-- =============================================
-- Create database template
-- =============================================
USE master
GO

-- Drop the database if it already exists
IF  EXISTS (
	SELECT name 
		FROM sys.databases 
		WHERE name = N'TestDatabase'
)
DROP DATABASE TestDatabase
GO

CREATE DATABASE TestDatabase
GO

USE TestDatabase
GO

IF OBJECT_ID('Tasks', 'U') IS NOT NULL
  DROP TABLE Tasks
GO

CREATE TABLE Tasks
(
	Id int NOT NULL identity, 
	Description nvarchar(255), 	
    CONSTRAINT PK_Tasks PRIMARY KEY (Id)
)
GO


INSERT INTO [Tasks]([Description]) VALUES  ('Pulire la cucina')
GO
INSERT INTO [Tasks]([Description]) VALUES  ('Fare la spesa')
GO

